3 visuals for webpage
This code will help produce the three visuals that are going to be a
part of each equity tracker indicator webpage: regional map (tract
level) of most recent data, chart of the most recent data, chart of
trends over time.
If the indicator is a PUMS/OPSI indicator that can be accessed
through Elmer. Getting the data to a workable version may
require some data transformation. To explore, clean, transform, and
generate a final data set, please use the
data-gen-pums-template. This script will generate an .rda for
the map and an .rda for the charts. These data sets will be loaded in
before the data visualization code.
Indicator Explanation
[Kindergarten readiness is an important and early predictor of high
school graduation. Recognizing the effectiveness and importance of the
first five years of life, there have been recent efforts to strengthen
early childhood programs in Washington state and the region. Readiness
for incoming kindergarteners in Washington is assessed by teachers who
observe students across six areas of development and learning: social
emotional, physical, language, cognitive, literacy and math. For this
measure, we are defining students as kindergarten ready if they
demonstrate readiness in all six areas.]
1. Map of most recent data
To map data in this form, it requires accessing the most recent data
from OSPI since the Elmer data set is already aggregated to equity
group/quintile.
Create Visual
Sources: Washington Office of Superintendent of Public Instruction
(OSPI) 2022-23 Washington Kindergarten Inventory of Developing Skills
(WaKIDS); U.S. Census Bureau, Geography Division 2020 TIGER/Line
Shapefiles
Data call outs
- 53%: The percentage of students ready for kindergarten in the
region
- 81%: Snoqualmie Valley School District (King County) has the highest
percentage of students ready for kindergarten
- 40%: Percentage point difference between school district with
highest proportion of kindergarten ready students and one with
lowest
Insights & Analysis
- King County has the highest proportion of students who are
kindergarten ready (59%), followed by Kitsap (52%), Pierce (47%), and
Snohomish (46%)
- Of the 37,800 kindergarten students in the four-county region,
almost half of them are in King County (49%), one-quarter are in Pierce
(25%), one-fifth are in Snohomish (20%), and the remaining are in Kitsap
(6%)
- There are 6 school districts that overlap 2 counties, 3 of which are
both in the PSRC region: Auburn School District (King and Pierce), Fife
School District (King and Pierce), and Northshore School District (King
and Snohomish); and 3 extend outside the region: Darrington School
District (Skagit and Snohomish), Eatonville School District (Lewis and
Pierce), and Stanwood-Camano School District (Island and Snohomish)
- Index School District (Snohomish County) and Skykomish School
District (King County) are the only two districts with suppressed
data
2. Facet of most recent data
Create Visual
Kindergarten Readiness
Percent of students demonstrating readiness in 6 of 6 domains*
Washington Office of Superintendent of Public Instruction (OSPI) 2022-23
Washington Kindergarten Inventory of Developing Skills (WaKIDS)
No
data available for students with limited English proficiency in Kitsap
County
*Social-Emotional, Physical, Language, Cognitive, Literacy,
and Math
Data call outs
- 37%: The percentage of students from households below 200% of the
poverty level who are kindergarten ready
- 33%: In 2022, the percentage of students ready for kindergarten was
33% lower for students with disabilities
- 11%: In 2022, fewer students of color were ready for kindergarten
than their white non-Hispanic counterparts, a difference of 11%
Insights & Analysis
- The smallest difference in kindergarten readiness between students
of color and white non-Hispanic students is in Kitsap County (3%), while
the largest difference is in King County (16%) - Pierce (11%) and
Snohomish (9%) fall in the middle
- For students who belong to households below 200% of the poverty
level, kindergarten readiness is lowest in Snohomish County (32%),
followed by Pierce (37%), King (38%), and Kitsap (48%)
- The largest difference in kindergarten readiness between students
with and without a disability is in King County (37%), while the
smallest difference is in Kitsap and Pierce Counties (28%)
- Available data are too limited to accurately report kindergarten
readiness for limited English proficient students in Kitsap County
3. Facet of trend data
Create Visual
Kindergarten Readiness
Percent of students demonstrating readiness in 6 of 6 domains*
Washington Office of Superintendent of Public Instruction (OSPI) 2021-23
Washington Kindergarten Inventory of Developing Skills (WaKIDS)
Limited data available for students with limited English proficiency in
Kitsap County
No data available for school year 2020-21
*Social-Emotional, Physical, Language, Cognitive, Literacy, and Math
Data call outs
- 10%: Students of color are less likely to be prepared for
kindergarten compared to white non-Hispanic students, a gap of 10% and a
decrease of 48% over the past decade
- 24%: The gap in kindergarten readiness between students from
low-income households and non-low income households has remained
relatively consistent in the last ten years, decreasing from 27% in 2011
to 24% in 2022
- 47%: Students with disabilities are less likely to be prepared for
kindergarten compared to students without disabilities, a gap which has
increased by 47% over time
Insights & Analysis
- The difference in kindergarten readiness between students of color
and white non-Hispanic over time has decreased regionally (-48%), with
the most noticeable increase in in Snohomish County (+13%) and the most
noticeable decrease in King County (-21%)
- The percentage of students prepared for kindergarten decreased over
the past decade for all groups in Pierce and Snohomish Counties, while
kindergarten readiness seemed in increase for all groups in King
County.
- In King County, the difference in kindergarten readiness between
students with and without a disability almost doubled over the past
decade (+95%), while the difference slightly increased in Snohomish
County (4%) and decreased in Pierce County (-10%). Kitsap County didn’t
report data for students with disabilities until 2015 and in the past
half decade, the difference has decreased slightly (-7%)